Del Real Commercial Internal Job Aid · Page Two
Capture Worksheet

What page two needsThe transactions.

Every comp = 7 fields
  • Identity — property & submarket
  • Size — units
  • Price — total & per unit
  • Yield — cap rate, if disclosed
  • Vintage & date — built, closed

Page two is the comps table — the part owners read first. Pull every qualifying multifamily sale that closed in the county this quarter, capture the seven fields below for each, then curate down to the 8–10 that tell the market's story. Lead with the deals you brokered.

Where the comps come from

In priority order
1Your own closed & active deals 2CoStar Sale Comps export 3Crexi · Sold 4Commercial / CCIM MLS 5County Recorder (verify price)

The seven fields, defined

One row per trade · maps to the table columns
1Property & submarketCol 1
The name owners would recognize, plus the city or submarket — Merced, Atwater, Los Banos, Livingston.
FindDeal file · CoStar property record · Crexi listing
2UnitsCol 2
Count of apartment units — the basis for price/unit. Confirm it's units, not buildings or parcels.
FindCoStar property record · rent roll
3Sale priceCol 3
Gross consideration — the total trade price, not per unit. Verify against the recorder when a source looks rounded.
FindCoStar sale comp · County Recorder · your file
4Price / unitCol 4
Sale price ÷ units — the comparability metric, and the number that feeds the page-one median. Double-check the math.
FindCoStar computes it · or divide it yourself
5Cap rateCol 5
Going-in yield, only if disclosed. Many private trades won't report one.
RuleIf undisclosed, leave an em-dash —. Never estimate it.
6Year builtCol 6
Original vintage. If a major renovation drove the price, note it in the read rather than the table.
FindCoStar · County Assessor
7Close dateCol 7
Recording date — must fall inside the quarter. Sort the finished table newest-first.
FindCoStar · County Recorder
∑Footer medianTotal row
After curating, compute the median of units, price, $/unit, and cap across the kept trades — that's the table's bottom row.
NoteMedian, not average, so one outlier can't skew it.

This quarter's capture

Fill the gold cells · Q ____ 20 ____

Log each qualifying trade, then strike the rows you cut. Aim to keep 8–10, with a spread of submarkets and your own deals included.

Property / Submarket Units Sale Price $ / Unit Cap Built Closed
01
02
03
04
05
06
07
08
09
10
Quarter median
Curate

When more than ten qualify, keep the ones that tell the story: the largest trades, a spread of submarkets, and any you brokered. De-identify if a seller asked to stay private — abstract the name, keep the numbers. Never pad the table with weak or off-market deals to reach ten.

Then write the read

Below the table, the "What this means for owners" note interprets the numbers in three moves — did the market firm, soften, or surge; what moved most; what it means for an owner weighing a transition. Keep it ~120 words, calm and advisory. Full guidance in the Data-Capture Playbook, Step 3.

Del Real Commercial Page Two Comps · Capture Job Aid DelRealCRE.com